DROP TABLE IF EXISTS wane_advertisement;
CREATE TABLE wane_advertisement (
  adid smallint(4) unsigned NOT NULL auto_increment,
  context text NOT NULL,
  PRIMARY KEY  (adid)
);

DROP TABLE IF EXISTS wane_alerm;
CREATE TABLE wane_alerm (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  sid mediumint(8) unsigned NOT NULL default '0',
  url varchar(120) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY sid (sid)
);

DROP TABLE IF EXISTS wane_announce;
CREATE TABLE wane_announce (
  nid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (nid),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_articles;
CREATE TABLE wane_articles (
  aid int(8) unsigned NOT NULL auto_increment,
  cid smallint(4) unsigned NOT NULL default '0',
  uid int(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  htmlroot varchar(10) NOT NULL default '',
  replies smallint(4) unsigned NOT NULL default '0',
  click mediumint(8) unsigned NOT NULL default '0',
  sign tinyint(1) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  lastuid mediumint(8) unsigned NOT NULL default '0',
  lastuser varchar(30) NOT NULL default '',
  lasttime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (aid),
  KEY cid (cid),
  KEY uid (uid),
  KEY title (title),
  KEY sign (sign),
  KEY lastuid (lastuid),
  KEY lastuser (lastuser),
  KEY lasttime (lasttime)
);

DROP TABLE IF EXISTS wane_articles_discuss;
CREATE TABLE wane_articles_discuss (
  id mediumint(8) unsigned NOT NULL auto_increment,
  aid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY aid (aid),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_classarticle;
CREATE TABLE wane_classarticle (
  id smallint(4) unsigned NOT NULL auto_increment,
  orderid smallint(4) unsigned NOT NULL default '0',
  title varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_classdiarybground;
CREATE TABLE wane_classdiarybground (
  id smallint(4) unsigned NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  url varchar(20) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_classdiarykidney;
CREATE TABLE wane_classdiarykidney (
  id smallint(4) unsigned NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  url varchar(20) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_classdiaryweather;
CREATE TABLE wane_classdiaryweather (
  id smallint(4) unsigned NOT NULL auto_increment,
  title varchar(20) NOT NULL default '',
  url varchar(20) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_classedu;
CREATE TABLE wane_classedu (
  eid smallint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (eid)
);

DROP TABLE IF EXISTS wane_classjob;
CREATE TABLE wane_classjob (
  jid smallint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (jid)
);

DROP TABLE IF EXISTS wane_classminzu;
CREATE TABLE wane_classminzu (
  mid smallint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (mid)
);

DROP TABLE IF EXISTS wane_classparty;
CREATE TABLE wane_classparty (
  id smallint(4) NOT NULL auto_increment,
  title varchar(30) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_classplace;
CREATE TABLE wane_classplace (
  pid smallint(6) unsigned NOT NULL auto_increment,
  uppid smallint(6) unsigned NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  orderid smallint(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid)
);

DROP TABLE IF EXISTS wane_classpurpose;
CREATE TABLE wane_classpurpose (
  pid smallint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid)
);

DROP TABLE IF EXISTS wane_links;
CREATE TABLE wane_links (
  id smallint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  img varchar(80) NOT NULL default '',
  url varchar(80) NOT NULL default '',
  context varchar(50) NOT NULL default '',
  orderid smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_log_admin;
CREATE TABLE wane_log_admin (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(30) NOT NULL default '',
  operate varchar(255) NOT NULL default '',
  ipaddr varchar(15) NOT NULL default '',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_log_pay;
CREATE TABLE wane_log_pay (
  pid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  paytype set('online','online_other','bank','mail') NOT NULL default 'online',
  orderid varchar(32) NOT NULL default '',
  status set('ok','error','unknow') NOT NULL default '',
  viplong smallint(3) unsigned NOT NULL default '0',
  ammount float unsigned NOT NULL default '0',
  moneytype tinyint(1) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_log_upgrade;
CREATE TABLE wane_log_upgrade (
  id mediumint(8) unsigned NOT NULL auto_increment,
  operater mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  op_before smallint(3) NOT NULL default '0',
  op_after smallint(3) NOT NULL default '0',
  viped int(10) unsigned NOT NULL default '0',
  viptime int(10) unsigned NOT NULL default '0',
  operate varchar(255) NOT NULL default '',
  ipaddr varchar(15) NOT NULL default '',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY operater (operater),
  KEY uid (uid,op_before,op_after,viptime)
);


DROP TABLE IF EXISTS wane_loveclaim;
CREATE TABLE wane_loveclaim (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  message varchar(255) NOT NULL default '',
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY uid (uid,addtime)
) ;

DROP TABLE IF EXISTS wane_member;
CREATE TABLE wane_member (
  uid mediumint(8) unsigned NOT NULL auto_increment,
  username varchar(30) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  kind smallint(3) NOT NULL default '0',
  question varchar(80) NOT NULL default '',
  answer varchar(80) NOT NULL default '',
  regtime int(10) unsigned NOT NULL default '0',
  regip varchar(15) NOT NULL default '',
  logins smallint(6) unsigned NOT NULL default '0',
  lastlogin int(10) unsigned NOT NULL default '0',
  lastupdate int(10) unsigned NOT NULL default '0',
  lastactive int(10) unsigned NOT NULL default '0',
  viptime int(10) unsigned NOT NULL default '0',
  photos smallint(3) unsigned NOT NULL default '0',
  diaries smallint(4) unsigned NOT NULL default '0',
  books smallint(4) unsigned NOT NULL default '0',
  articles smallint(4) unsigned NOT NULL default '0',
  seek smallint(4) unsigned NOT NULL default '0',
  seeked smallint(4) unsigned NOT NULL default '0',
  friend smallint(4) unsigned NOT NULL default '0',
  friended smallint(4) unsigned NOT NULL default '0',
  soundpm tinyint(1) unsigned NOT NULL default '0',
  newpm smallint(4) unsigned NOT NULL default '0',
  pms smallint(4) unsigned NOT NULL default '0',
  credits mediumint(8) unsigned NOT NULL default '0',
  commend tinyint(1) unsigned NOT NULL default '0',
  commend_order smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (uid),
  KEY uid (uid),
  KEY kind (kind),
  KEY regtime (regtime),
  KEY lastlogin (lastlogin),
  KEY lastupdate (lastupdate),
  KEY photos (photos),
  KEY pms (pms),
  KEY credits (credits),
  KEY lastactive (lastactive),
  KEY viptime (viptime),
  KEY commend (commend)
);

DROP TABLE IF EXISTS wane_memberbook;
CREATE TABLE wane_memberbook (
  bid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  vid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (bid)
);

DROP TABLE IF EXISTS wane_memberdiary;
CREATE TABLE wane_memberdiary (
  did mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  today int(10) unsigned NOT NULL default '0',
  weather varchar(20) NOT NULL default '',
  kidney varchar(20) NOT NULL default '',
  background varchar(20) NOT NULL default '',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  sign tinyint(1) unsigned NOT NULL default '0',
  htmlroot varchar(10) NOT NULL default '',
  replies smallint(4) unsigned NOT NULL default '0',
  click mediumint(8) unsigned NOT NULL default '0',
  lastuid mediumint(8) unsigned NOT NULL default '0',
  lastuser varchar(30) NOT NULL default '',
  lastupdate int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (did),
  KEY sign (sign),
  KEY today (today),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_memberdiary_discuss;
CREATE TABLE wane_memberdiary_discuss (
  id mediumint(8) unsigned NOT NULL auto_increment,
  did mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY did (did,uid)
);

DROP TABLE IF EXISTS wane_memberfields;
CREATE TABLE wane_memberfields (
  id mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(30) NOT NULL default '',
  nickname varchar(20) NOT NULL default '',
  truename varchar(10) NOT NULL default '',
  sex tinyint(1) unsigned NOT NULL default '1',
  year smallint(4) unsigned NOT NULL default '0',
  md varchar(5) NOT NULL default '',
  height smallint(3) unsigned NOT NULL default '0',
  weight smallint(3) unsigned NOT NULL default '0',
  star varchar(8) NOT NULL default '',
  animal varchar(8) NOT NULL default '',
  blood varchar(8) NOT NULL default '',
  marry varchar(8) NOT NULL default '',
  workadd varchar(14) NOT NULL default '',
  province mediumint(5) unsigned NOT NULL default '0',
  city smallint(5) unsigned NOT NULL default '0',
  edu smallint(3) unsigned NOT NULL default '0',
  graedu varchar(40) NOT NULL default '',
  job smallint(3) unsigned NOT NULL default '0',
  salary varchar(8) NOT NULL default '',
  house varchar(8) NOT NULL default '',
  family varchar(8) NOT NULL default '',
  purpose smallint(3) unsigned NOT NULL default '0',
  introduce text NOT NULL,
  kidney varchar(8) NOT NULL default '',
  body varchar(8) NOT NULL default '',
  minzu smallint(4) unsigned NOT NULL default '0',
  belief varchar(8) NOT NULL default '',
  smoke varchar(8) NOT NULL default '',
  drink varchar(8) NOT NULL default '',
  email varchar(80) NOT NULL default '',
  msn varchar(80) NOT NULL default '',
  qq int(20) NOT NULL default '0',
  icq int(20) NOT NULL default '0',
  yahoo varchar(80) NOT NULL default '',
  phone varchar(80) NOT NULL default '',
  other varchar(200) NOT NULL default '',
  img varchar(255) NOT NULL default '',
  imgsign tinyint(1) unsigned NOT NULL default '0',
  imgtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY nickname (nickname),
  KEY sex (sex),
  KEY year (year),
  KEY md (md),
  KEY marry (marry),
  KEY workadd (workadd),
  KEY province (province),
  KEY edu (edu),
  KEY graedu (graedu),
  KEY salary (salary),
  KEY kidney (kidney),
  KEY img (img),
  KEY imgsign (imgsign),
  KEY imgtime (imgtime)
);

DROP TABLE IF EXISTS wane_memberforto;
CREATE TABLE wane_memberforto (
  id mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(30) NOT NULL default '',
  s_age smallint(2) unsigned NOT NULL default '0',
  e_age smallint(2) unsigned NOT NULL default '0',
  s_height smallint(3) unsigned NOT NULL default '0',
  e_height smallint(3) unsigned NOT NULL default '0',
  s_weight smallint(3) unsigned NOT NULL default '0',
  e_weight smallint(3) unsigned NOT NULL default '0',
  salary varchar(8) NOT NULL default '',
  sex tinyint(1) NOT NULL default '-1',
  marry varchar(8) NOT NULL default '',
  province varchar(25) NOT NULL default '',
  edu varchar(8) NOT NULL default '',
  job varchar(50) NOT NULL default '',
  img tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_memberfriends;
CREATE TABLE wane_memberfriends (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  fid mediumint(8) unsigned NOT NULL default '0',
  sign tinyint(1) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid,fid),
  KEY sign (sign)
);

DROP TABLE IF EXISTS wane_memberlovy;
CREATE TABLE wane_memberlovy (
  id mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  username varchar(50) NOT NULL default '',
  language varchar(100) NOT NULL default '',
  party varchar(100) NOT NULL default '',
  sports varchar(200) NOT NULL default '',
  movies varchar(255) NOT NULL default '',
  music varchar(255) NOT NULL default '',
  food varchar(100) NOT NULL default '',
  place varchar(255) NOT NULL default '',
  firstmeet varchar(255) NOT NULL default '',
  lovelike varchar(255) NOT NULL default '',
  life varchar(255) NOT NULL default '',
  yuanwang varchar(255) NOT NULL default '',
  fav varchar(255) NOT NULL default '',
  hate varchar(100) NOT NULL default '',
  agreeage varchar(255) NOT NULL default '',
  disagreeage varchar(255) NOT NULL default '',
  body varchar(50) NOT NULL default '',
  thing varchar(255) NOT NULL default '',
  applyman varchar(40) NOT NULL default '',
  book varchar(100) NOT NULL default '',
  movie varchar(100) NOT NULL default '',
  song varchar(100) NOT NULL default '',
  color varchar(12) NOT NULL default '',
  star varchar(100) NOT NULL default '',
  job varchar(100) NOT NULL default '',
  stupid varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_memberphotos;
CREATE TABLE wane_memberphotos (
  id mediumint(8) NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  img varchar(255) NOT NULL default '',
  imgsign tinyint(1) unsigned NOT NULL default '0',
  imgtime int(10) unsigned NOT NULL default '0',
  title varchar(50) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY img (img),
  KEY imgsign (imgsign),
  KEY imgtime (imgtime)
);

DROP TABLE IF EXISTS wane_memberseek;
CREATE TABLE wane_memberseek (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  sid mediumint(8) unsigned NOT NULL default '0',
  sign tinyint(1) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid,sid),
  KEY sign (sign)
);

DROP TABLE IF EXISTS wane_memberview;
CREATE TABLE wane_memberview (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  vid mediumint(8) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  wane_hash varchar(32) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY vid (vid),
  KEY addtime (addtime),
  KEY wane_hash (wane_hash)
);

DROP TABLE IF EXISTS wane_party;
CREATE TABLE wane_party (
  pid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  cid smallint(4) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  place_main smallint(6) unsigned NOT NULL default '0',
  place_sec smallint(6) unsigned NOT NULL default '0',
  address varchar(50) NOT NULL default '',
  party_time varchar(80) NOT NULL default '',
  losetime int(10) unsigned NOT NULL default '0',
  peoples smallint(4) unsigned NOT NULL default '0',
  money_s smallint(4) unsigned NOT NULL default '0',
  money_e smallint(8) unsigned NOT NULL default '0',
  contact varchar(80) NOT NULL default '',
  context text NOT NULL,
  sign tinyint(1) unsigned NOT NULL default '0',
  top tinyint(1) unsigned NOT NULL default '0',
  img varchar(255) NOT NULL default '',
  htmlroot varchar(10) NOT NULL default '',
  addtime int(10) unsigned NOT NULL default '0',
  orderid smallint(4) unsigned NOT NULL default '0',
  joins smallint(4) unsigned NOT NULL default '1',
  replies smallint(4) unsigned NOT NULL default '0',
  lastuid mediumint(8) unsigned NOT NULL default '0',
  lastuser varchar(30) NOT NULL default '',
  lasttime int(10) unsigned NOT NULL default '0',
  photos smallint(3) unsigned NOT NULL default '0',
  click smallint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (pid),
  KEY uid (uid),
  KEY cid (cid),
  KEY title (title),
  KEY losetime (losetime),
  KEY peoples (peoples),
  KEY money_s (money_s),
  KEY money_e (money_e),
  KEY sign (sign),
  KEY top (top),
  KEY htmlroot (htmlroot),
  KEY joins (joins),
  KEY replies (replies),
  KEY lastuid (lastuid),
  KEY lastuser (lastuser),
  KEY lasttime (lasttime),
  KEY photos (photos),
  KEY place_main (place_main,place_sec)
);

DROP TABLE IF EXISTS wane_party_discuss;
CREATE TABLE wane_party_discuss (
  id mediumint(8) unsigned NOT NULL auto_increment,
  pid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(15) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY pid (pid),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_party_joins;
CREATE TABLE wane_party_joins (
  id mediumint(8) unsigned NOT NULL auto_increment,
  pid mediumint(8) unsigned NOT NULL default '0',
  uid mediumint(8) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY pid (pid),
  KEY uid (uid)
);

DROP TABLE IF EXISTS wane_party_photos;
CREATE TABLE wane_party_photos (
  id mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  pid mediumint(8) unsigned NOT NULL default '0',
  title varchar(80) NOT NULL default '',
  img varchar(38) NOT NULL default '',
  sign tinyint(1) unsigned NOT NULL default '0',
  addtime int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY uid (uid),
  KEY pid (pid),
  KEY sign (sign),
  KEY addtime (addtime)
);

DROP TABLE IF EXISTS wane_pms;
CREATE TABLE wane_pms (
  pmid mediumint(8) unsigned NOT NULL auto_increment,
  uid mediumint(8) unsigned NOT NULL default '0',
  sid mediumint(8) unsigned NOT NULL default '0',
  system tinyint(1) unsigned NOT NULL default '0',
  gid varchar(50) NOT NULL default '',
  isnew tinyint(1) unsigned NOT NULL default '1',
  title varchar(80) NOT NULL default '',
  context text NOT NULL,
  addtime int(10) unsigned NOT NULL default '0',
  ipaddr varchar(16) NOT NULL default '',
  PRIMARY KEY  (pmid),
  KEY recid (uid,sid,system)
);

DROP TABLE IF EXISTS wane_setting;
CREATE TABLE wane_setting (
  setid tinyint(1) unsigned NOT NULL auto_increment,
  members mediumint(8) unsigned NOT NULL default 0,
  female mediumint(8) unsigned NOT NULL default 0,
  male mediumint(8) unsigned NOT NULL default 0,
  diaries mediumint(8) unsigned NOT NULL default 0,
  parties mediumint(8) unsigned NOT NULL default 0,
  articles mediumint(8) unsigned NOT NULL default 0,
  lastupdate int(10) unsigned NOT NULL default 0,
  PRIMARY KEY  (setid)
);

DROP TABLE IF EXISTS wane_style;
CREATE TABLE wane_style (
  id smallint(4) unsigned NOT NULL auto_increment,
  tid smallint(4) unsigned NOT NULL default '0',
  title varchar(30) NOT NULL default '',
  templatedir varchar(50) NOT NULL default '',
  imgdir varchar(50) NOT NULL default '',
  charset varchar(12) NOT NULL default '',
  link varchar(7) NOT NULL default '',
  link_under set('none','underline') NOT NULL default 'none',
  link_hover varchar(7) NOT NULL default '',
  link_hover_under set('none','underline') NOT NULL default 'underline',
  font_size smallint(3) unsigned NOT NULL default '12',
  font_color varchar(7) NOT NULL default '',
  background varchar(50) NOT NULL default '',
  frontground varchar(50) NOT NULL default '',
  categround varchar(50) NOT NULL default '',
  catefont varchar(7) NOT NULL default '',
  catesize smallint(3) unsigned NOT NULL default '14',
  titleground varchar(50) NOT NULL default '',
  titlefont varchar(7) NOT NULL default '',
  titlesize smallint(3) unsigned NOT NULL default '12',
  contentground varchar(50) NOT NULL default '',
  contentfont varchar(7) NOT NULL default '',
  contentsize smallint(3) unsigned NOT NULL default '12',
  changeground varchar(50) NOT NULL default '',
  tablewidth varchar(4) NOT NULL default '',
  tablespace smallint(2) unsigned NOT NULL default '5',
  tablecell smallint(2) NOT NULL default '1',
  tableborder_color varchar(7) NOT NULL default '',
  tableborder_incolor varchar(7) NOT NULL default '',
  tableborder_size smallint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (id)
);

DROP TABLE IF EXISTS wane_template;
CREATE TABLE wane_template (
  tid mediumint(4) unsigned NOT NULL auto_increment,
  title varchar(50) NOT NULL default '',
  charset varchar(20) NOT NULL default '',
  templatedir varchar(50) NOT NULL default '',
  imgdir varchar(50) NOT NULL default '',
  PRIMARY KEY  (tid),
  KEY tid (tid)
);

DROP TABLE IF EXISTS wane_usergroup;
CREATE TABLE wane_usergroup (
  gid smallint(4) NOT NULL auto_increment,
  title varchar(30) NOT NULL default '',
  kind smallint(4) NOT NULL default '0',
  memcpphoto_sign tinyint(1) unsigned NOT NULL default '0',
  memcpphotos tinyint(1) unsigned NOT NULL default '0',
  memcpphotos_sign tinyint(1) unsigned NOT NULL default '0',
  memcptop tinyint(1) unsigned NOT NULL default '1',
  memcpdiary tinyint(1) unsigned NOT NULL default '1',
  memcpbook tinyint(1) unsigned NOT NULL default '1',
  memcppm tinyint(1) unsigned NOT NULL default '1',
  memcppm_num smallint(4) unsigned NOT NULL default '0',
  view_basic tinyint(1) unsigned NOT NULL default '1',
  view_lovy tinyint(1) unsigned NOT NULL default '1',
  view_forto tinyint(1) unsigned NOT NULL default '1',
  view_photos tinyint(1) unsigned NOT NULL default '0',
  view_contact tinyint(1) unsigned NOT NULL default '0',
  view_diary tinyint(1) unsigned NOT NULL default '1',
  view_book tinyint(1) unsigned NOT NULL default '1',
  make_friend tinyint(1) unsigned NOT NULL default '1',
  make_seek tinyint(1) unsigned NOT NULL default '1',
  make_book tinyint(1) unsigned NOT NULL default '1',
  make_pm tinyint(1) unsigned NOT NULL default '1',
  party_make tinyint(1) unsigned NOT NULL default '1',
  party_sign tinyint(1) unsigned NOT NULL default '0',
  party_join tinyint(1) unsigned NOT NULL default '1',
  party_photos tinyint(1) unsigned NOT NULL default '1',
  party_photos_sign tinyint(1) unsigned NOT NULL default '0',
  article_make tinyint(1) unsigned NOT NULL default '1',
  article_sign tinyint(1) unsigned NOT NULL default '0',
  star_join tinyint(1) unsigned NOT NULL default '1',
  friend_match tinyint(1) unsigned NOT NULL default '0',
  friend_lastview tinyint(1) unsigned NOT NULL default '0',
  friend_search tinyint(1) unsigned NOT NULL default '0',
  friend_onlinefemale tinyint(1) unsigned NOT NULL default '0',
  friend_onlinemale tinyint(1) unsigned NOT NULL default '0',
  friend_newfemale tinyint(1) unsigned NOT NULL default '0',
  friend_newmale tinyint(1) unsigned NOT NULL default '0',
  friend_creditsfemale tinyint(1) unsigned NOT NULL default '0',
  friend_creditsmale tinyint(1) unsigned NOT NULL default '0',
  friend_loginfemale tinyint(1) unsigned NOT NULL default '0',
  friend_loginmale tinyint(1) unsigned NOT NULL default '0',
  friend_cityfemale tinyint(1) unsigned NOT NULL default '0',
  friend_citymale tinyint(1) unsigned NOT NULL default '0',
  friend_photofemale tinyint(1) unsigned NOT NULL default '0',
  friend_photomale tinyint(1) unsigned NOT NULL default '0',
  friend_diaryfemale tinyint(1) unsigned NOT NULL default '0',
  friend_diarymale tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (gid),
  KEY memcppm (memcppm,memcppm_num)
);


INSERT INTO wane_classarticle VALUES('1','0','Default Article');
INSERT INTO wane_classdiarybground VALUES('1','','1.gif','0');
INSERT INTO wane_classdiarybground VALUES('2','ɫ','2.gif','0');
INSERT INTO wane_classdiarybground VALUES('3','ɢ','3.gif','0');
INSERT INTO wane_classdiarykidney VALUES('1','','1.gif','0');
INSERT INTO wane_classdiarykidney VALUES('2','Ծ','2.gif','0');
INSERT INTO wane_classdiarykidney VALUES('3','ץ','3.gif','0');
INSERT INTO wane_classdiarykidney VALUES('4','','4.gif','0');
INSERT INTO wane_classdiarykidney VALUES('5','','5.gif','0');
INSERT INTO wane_classdiarykidney VALUES('6','ŭ','6.gif','0');
INSERT INTO wane_classdiarykidney VALUES('7','ɵЦ','7.gif','0');
INSERT INTO wane_classdiarykidney VALUES('8','ɻ','8.gif','0');
INSERT INTO wane_classdiarykidney VALUES('9','̾','9.gif','0');
INSERT INTO wane_classdiarykidney VALUES('10','޾','10.gif','0');
INSERT INTO wane_classdiaryweather VALUES('1','','1.gif','0');
INSERT INTO wane_classdiaryweather VALUES('2','','2.gif','0');
INSERT INTO wane_classdiaryweather VALUES('3','','3.gif','0');
INSERT INTO wane_classdiaryweather VALUES('4','','4.gif','0');
INSERT INTO wane_classdiaryweather VALUES('5','ס','5.gif','0');
INSERT INTO wane_classdiaryweather VALUES('6','ѩ','6.gif','0');
INSERT INTO wane_classedu VALUES('','Defaul Education','0');
INSERT INTO wane_classjob VALUES('','Defaul Job','0');
INSERT INTO wane_classminzu VALUES('1','Default Nation','0');
INSERT INTO wane_classparty VALUES('1','Default Party','0');
INSERT INTO wane_classplace VALUES('1','0','Province','0');
INSERT INTO wane_classplace VALUES('2','1','City','0');
INSERT INTO wane_classpurpose VALUES('1','Default Purpose','1');
INSERT INTO wane_links VALUES('1','WeSpace','http://www.wan-e.net/e.gif','http://www.wan-e.net','http://www.wan-e.net','0');
INSERT INTO wane_style VALUES('1','1','Default','default/','images/default/','gb2312','#990000','none','#990000','underline','12','#990000','bg.gif','front_bg.gif','cate_bg.gif','#ffffff','12','title_bg.gif','#990000','12','#ffffff','#990000','12','#f8f8f8','778','4','1','#ffffff','#efefef','1');
INSERT INTO wane_template VALUES('1','Default','gb2312','default/','images/default/');
INSERT INTO wane_usergroup VALUES (1, 'Guest', -2, 0, 1, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO wane_usergroup VALUES (2, 'Administrator', -1, 1, 0, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO wane_usergroup VALUES (3, 'Member', 0, 0, 3, 0, 1, 1, 1, 1, 50, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 1, 0, 1, 0, 1, 0, 1, 0, 0, 0, 0, 0, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1);
INSERT INTO wane_usergroup VALUES (4, 'VIP Member', 1, 1, 12, 1, 1, 1, 1, 1, 100, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1);